load data
truncate                                       
into table CRST_RCV_TRANSACTIONS
fields terminated by "	"                      
trailing nullcols 
( TRANSACTION_ID                ,
  LAST_UPDATE_DATE              Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATED_BY               ,
  CREATION_DATE                 Date "YYYYMMDD HH24:MI:SS",
  CREATED_BY                    ,
  LAST_UPDATE_LOGIN             ,
  REQUEST_ID                    ,
  PROGRAM_APPLICATION_ID        ,
  PROGRAM_ID                    ,
  PROGRAM_UPDATE_DATE           Date "YYYYMMDD HH24:MI:SS",
  TRANSACTION_TYPE              ,
  TRANSACTION_DATE              Date "YYYYMMDD HH24:MI:SS",
  QUANTITY                      ,
  UNIT_OF_MEASURE               ,
  SHIPMENT_HEADER_ID            ,
  SHIPMENT_LINE_ID              ,
  USER_ENTERED_FLAG             ,
  INTERFACE_SOURCE_CODE         ,
  INTERFACE_SOURCE_LINE_ID      ,
  INV_TRANSACTION_ID            ,
  SOURCE_DOCUMENT_CODE          ,
  DESTINATION_TYPE_CODE         ,
  PRIMARY_QUANTITY              ,
  PRIMARY_UNIT_OF_MEASURE       ,
  UOM_CODE                      ,
  EMPLOYEE_ID                   ,
  PARENT_TRANSACTION_ID         ,
  PO_HEADER_ID                  ,
  PO_RELEASE_ID                 ,
  PO_LINE_ID                    ,
  PO_LINE_LOCATION_ID           ,
  PO_DISTRIBUTION_ID            ,
  PO_REVISION_NUM               ,
  REQUISITION_LINE_ID           ,
  PO_UNIT_PRICE                 ,
  CURRENCY_CODE                 ,
  CURRENCY_CONVERSION_TYPE      ,
  CURRENCY_CONVERSION_RATE      ,
  CURRENCY_CONVERSION_DATE      Date "YYYYMMDD HH24:MI:SS",
  ROUTING_HEADER_ID             ,
  ROUTING_STEP_ID               ,
  DELIVER_TO_PERSON_ID          ,
  DELIVER_TO_LOCATION_ID        ,
  VENDOR_ID                     ,
  VENDOR_SITE_ID                ,
  ORGANIZATION_ID               ,
  SUBINVENTORY                  ,
  LOCATOR_ID                    ,
  WIP_ENTITY_ID                 ,
  WIP_LINE_ID                   ,
  WIP_REPETITIVE_SCHEDULE_ID    ,
  WIP_OPERATION_SEQ_NUM         ,
  WIP_RESOURCE_SEQ_NUM          ,
  BOM_RESOURCE_ID               ,
  LOCATION_ID                   ,
  SUBSTITUTE_UNORDERED_CODE     ,
  RECEIPT_EXCEPTION_FLAG        ,
  INSPECTION_STATUS_CODE        ,
  ACCRUAL_STATUS_CODE           ,
  INSPECTION_QUALITY_CODE       ,
  VENDOR_LOT_NUM                ,
  RMA_REFERENCE                 ,
  COMMENTS                      ,
  ATTRIBUTE_CATEGORY            ,
  ATTRIBUTE1                    ,
  ATTRIBUTE2                    ,
  ATTRIBUTE3                    ,
  ATTRIBUTE4                    ,
  ATTRIBUTE5                    ,
  ATTRIBUTE6                    ,
  ATTRIBUTE7                    ,
  ATTRIBUTE8                    ,
  ATTRIBUTE9                    ,
  ATTRIBUTE10                   ,
  ATTRIBUTE11                   ,
  ATTRIBUTE12                   ,
  ATTRIBUTE13                   ,
  ATTRIBUTE14                   ,
  ATTRIBUTE15                   ,
  REQ_DISTRIBUTION_ID           ,
  DEPARTMENT_CODE               ,
  REASON_ID                     ,
  DESTINATION_CONTEXT           ,
  LOCATOR_ATTRIBUTE             ,
  CHILD_INSPECTION_FLAG         ,
  SOURCE_DOC_UNIT_OF_MEASURE    ,
  SOURCE_DOC_QUANTITY           ,
  INTERFACE_TRANSACTION_ID      ,
  GROUP_ID                      ,
  MOVEMENT_ID                   ,
  INVOICE_ID                    ,
  INVOICE_STATUS_CODE           ,
  QA_COLLECTION_ID              ,
  MRC_CURRENCY_CONVERSION_TYPE  ,
  MRC_CURRENCY_CONVERSION_DATE  ,
  MRC_CURRENCY_CONVERSION_RATE  ,
  COUNTRY_OF_ORIGIN_CODE        ,
  MVT_STAT_STATUS               ,
  QUANTITY_BILLED               ,
  MATCH_FLAG                    ,
  AMOUNT_BILLED                 ,
  MATCH_OPTION                  ,
  OE_ORDER_HEADER_ID            ,
  OE_ORDER_LINE_ID              ,
  CUSTOMER_ID                   ,
  CUSTOMER_SITE_ID              ,
  LPN_ID                        ,
  TRANSFER_LPN_ID               ,
  MOBILE_TXN                    ,
  SECONDARY_QUANTITY            ,
  SECONDARY_UNIT_OF_MEASURE     ,
  QC_GRADE                      ,
  SECONDARY_UOM_CODE            ,
  PA_ADDITION_FLAG              ,
  CONSIGNED_FLAG                
)
